<?php


$opts['tb'] = $PACTS_cfg->postcodesuburbmappingtablename;

// Name of field which is the unique key
$opts['key'] = 'Suburb';

// Type of key field (int/real/string/date etc.)
$opts['key_type'] = 'string';

// Sorting field(s)
$opts['sort_field'] = array('Suburb');


// Number of records to display on the screen
// Value of -1 lists all records in a table
$opts['inc'] = 200;





$opts['fdd']['Postcode'] = array(
  'name'     => 'Postcode',
  'select'   => 'T',
  'maxlen'   => 10,
  'default'  => '',
  'required' => true,
  'sort'     => true
);

$opts['fdd']['Postcode']['values']['table']   = 'Postcode';
$opts['fdd']['Postcode']['values']['column']   =  'Postcode';

$opts['fdd']['Suburb'] = array(
  'name'     => 'Suburb',
  'select'   => 'T',
  'maxlen'   => 50,
  'default'  => '',
  'required' => true,
  'sort'     => true
);

$opts['fdd']['Suburb']['values']['table']   = 'Suburb';
$opts['fdd']['Suburb']['values']['column']   =  'Suburb';

$opts['fdd']['StateCode'] = array(
  'name'     => 'StateCode',
  'select'   => 'T',
  'maxlen'   => 3,
  'default'  => '',
  'required' => true,
  'sort'     => true
);

$opts['fdd']['StateCode']['values']['table']   = 'State';
$opts['fdd']['StateCode']['values']['column']   =  'StateCode';
$opts['fdd']['StateCode']['values']['description']   = 'Description';

$opts['fdd']['Category'] = array(
  'name'     => 'Category',
  'select'   => 'T',
  'maxlen'   => 30,
  'default'  => 'PRI',
  'required' => true,
  'sort'     => true
);
$opts['fdd']['Category']['values']['table']   = 'Category';
$opts['fdd']['Category']['values']['column']   =  'Category';


new phpMyEdit($opts);

?>

